Purpose

Keep track of status of krypto portfolio over time, based on transactions combined with current price data.

Method

  1. Log into crypto account.
  2. John > Statements & Reports > Get latest annual or monthly stmt.
  3. Retrieve stmt from email. (new format as of 2022, but cols still align)
  4. Go to spreadsheet in Marengo - check most recent transaction date there.
  5. Copy/paste new transactions from activity report.
  6. Copy down formulas in spreadsheet.

Bitcoin

date symb acb price_close diff
2025-05-19 BTC-CAD $48,713.25 $147,350.53 202.49%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

  • Cdn dollar value
  1. Get latest price data.
  2. Combine with cost data.
  3. Calculate profit and ROI.

Ethereum

date symb acb price_close diff
2025-05-19 ETH-CAD $1,914.50 $3,521.61 83.94%

Transactions & Adjusted Cost Base (Avg Cost)

Price, Costs, Profits

Cardano

date symb acb price_close diff
2025-05-19 ADA-CAD $2.29 $1.04 -54.70%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

Polkadot

date symb acb price_close diff
2025-05-19 DOT-CAD $34.31 $6.43 -81.26%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

Litecoin

date symb acb price_close diff
2025-05-19 LTC-CAD $228.96 $138.42 -39.54%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

PRICE-COST SMRY

date symb acb price_close diff
2025-05-19 BTC-CAD $48,713.25 $147,350.53 202.49%
2025-05-19 ETH-CAD $1,914.50 $3,521.61 83.94%
2025-05-19 ADA-CAD $2.29 $1.04 -54.70%
2025-05-19 DOT-CAD $34.31 $6.43 -81.26%
2025-05-19 LTC-CAD $228.96 $138.42 -39.54%

TOTALS - Returns

date currency book_val market_val profit roi
2025-05-19 BTC $3,627 $10,972 7,345 202%
2025-05-19 ETH $7,676 $14,120 6,444 84%
2025-05-19 ADA $7,330 $3,321 (4,009) -55%
2025-05-19 DOT $3,465 $649 (2,815) -81%
2025-05-19 LTC $2,305 $1,394 (911) -40%
date total_invested total_market_val total_profit total_roi
2025-05-19 $24,403 $30,456 $6,054 25%